Execute SQL File
Overview
This function executes a text file consisting of one or more SQL Statements.
Note: any lines beginning with two slashes ('//') is treated as a comment
line.
How to Invoke
Use the menu item "Utilities > Database Utilities > Execute SQL File" .
Basic Procedure
- Select the SQL file to execute by using the "Select" button.
- Important! Review the SQL file carefully in the Review box.
- Click the "Execute" button to execute the SQL file.
Window Controls
"Select" button
Clicking this button brings up the standard file selector. Choose the SQL
file that you wish to execute. When you select the SQL file, the contents
will be shown in the Review text box.
"Review" text box
This shows the contents of the SQL file that you selected. It is highly
recommended that you review each and every line in the SQL file, since it
can drastically effect the database.
"Execute" button
Clicking this button executes the SQL file.Select button Clicking this
button brings up the standard file selector. Choose the SQL file that you
wish to execute.
"Log Errors Only" checkbox
If checked, only errors will show up in the "Process Log" text box.
Otherwise, every line in original SQL file will appear, with the results.
"Copy" button
This button copies the contents of the Process Log into the System
Clipboard.
"Save" button
This button saves the contents of the Process Log as a text file.